SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001363s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107678 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107678 [ RunTime:0.001810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (426535,657951,349858,371713,759752,725368,870654,106796,638063,40547,830986,815666,425646,198482,852180,847546,722453,472731,148247,1043366,671793,903750,452734,1006875,343810,305371,480865,115442,851142,532704,400848,354035,32965,262955,785225,508338,298164,715523,227553,985284,113666,345103,476792,136514,573675,790658,692279,270091,120142,766140,903222,71248,650868,607740,524598,123321,21735,716977,651143,503940) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107678 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107678 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]