SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 367518 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 367518 [ RunTime:0.002711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (592551,42887,84131,534248,1035146,408783,27477,812359,277785,873920,519815,1008049,388246,197082,181210,277519,270396,270800,634552,661060,54903,129442,901798,326936,437104,175102,36830,793096,567285,594944,677932,218581,344265,71585,805197,1537,206154,270145,671715,51564,128395,743472,479237,359136,545260,936952,967387,628042,567356,542250,712373,824800,644207,637977,208822,180665,330736,424093,1017187,57192) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001732s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 367518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000522s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 367518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000659s ]