SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 423315 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 423315 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (910952,718144,975121,138297,196086,994226,348226,26744,500837,201539,1019841,719488,395118,963269,323576,57823,415864,948988,392780,591369,544371,98466,102120,1001979,389356,807693,233468,875768,936598,750010,76705,658394,119331,149178,970916,614250,883560,241023,320234,158569,728048,124909,13929,305484,863410,24326,961722,541283,123079,925234,1015414,458103,1015827,54125,810963,93233,200676,515539,46984,283813) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001087s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 423315 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 423315 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]