SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267723 LIMIT 1 [ RunTime:0.000376s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267723 [ RunTime:0.001849s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141929,1038907,509158,981719,147846,9108,435623,119174,146465,558801,420472,491781,703608,879528,565657,769609,230097,161215,549640,95008,949122,581905,236111,69131,676222,850971,280866,627985,992432,884875,396069,605793,9885,1042177,843080,312732,800799,400709,610642,116712,784507,673731,933667,910027,864737,109011,538722,888816,370960,78590,222805,376130,353528,271548,413370,875512,205439,398798,905309,103816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267723 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000563s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267723 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]