SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001355s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807141 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807141 [ RunTime:0.003789s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (436940,337653,139540,452901,540861,622115,762413,916844,1038447,909754,1032084,464092,248391,298049,73505,824028,933725,859318,7113,629918,687097,545038,780214,62071,332673,376018,670112,458962,419481,468830,508366,740900,324233,103915,158138,748474,663762,232035,823298,499053,735451,67469,808911,566576,582842,993824,382771,262597,483457,919999,287064,49198,377030,619602,467112,633617,98150,98686,425020,859449) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.035108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807141 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807141 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000617s ]