SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045697 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045697 [ RunTime:0.001792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (976245,213019,1021073,463060,871654,826781,335455,87055,523707,918408,303216,390292,54393,189284,540603,678326,829597,750934,583045,485835,678384,843298,193274,965986,267732,509299,89008,74418,448548,83236,666882,241239,301441,176317,773877,1013889,789903,746484,975805,752171,740656,819422,194608,876304,119142,435731,631375,84553,154280,11397,684093,614529,101061,871476,56267,560310,75261,645157,106981,731128) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045697 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045697 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]