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` = 104382 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104382 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693935,999524,971391,252415,506743,324564,452470,918259,246700,184018,892261,1036348,727803,1035829,1028547,811192,641893,713085,863377,893968,21092,794241,195471,59283,629093,686606,420132,480684,1021320,898335,754565,500761,445553,286882,549222,59101,719855,538727,681907,710902,304652,526526,749605,403024,392917,664471,413152,933605,120792,609821,502285,589215,450335,546315,945072,490443,470915,531927,376399,81201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001650s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104382 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104382 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]