SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001443s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014472 LIMIT 1 [ RunTime:0.001178s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014472 [ RunTime:0.003638s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831026,661387,836858,132523,350850,393027,371161,280694,209940,350086,232122,419889,354709,252678,122372,1041163,456392,742551,1013793,433295,658918,98879,874844,639855,995259,870328,560487,363694,929399,65631,924986,738457,683898,464784,144966,150496,564086,591179,834009,477903,132326,260481,907810,742744,132165,276468,176970,154793,766956,148843,298356,144180,466400,671568,358624,873918,989621,912818,454900,734129) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014472 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014472 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]