SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046320 LIMIT 1 [ RunTime:0.000969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046320 [ RunTime:0.001685s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878597,813597,109637,758202,105207,540532,515056,575489,527443,912994,954741,178267,715210,343105,491953,285957,376877,374169,86966,11570,982299,768012,37504,916040,503426,405033,764510,810187,253740,13884,721655,977777,364358,699241,754833,440685,313631,985821,776383,890958,351002,25631,552078,527168,171674,989824,634625,71933,933706,92867,104459,474812,823579,456314,352461,88824,145460,345910,873521,522033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]