SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001945s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294581 LIMIT 1 [ RunTime:0.004077s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294581 [ RunTime:0.004297s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (352027,107084,859215,823662,425814,195292,779559,490957,460895,1007056,680807,812575,54478,655643,1011169,634360,490589,540941,752105,180857,570984,1017451,896468,226291,39665,792426,760535,291050,165321,918819,624521,233501,1003408,3580,141509,255337,6928,809583,734019,38486,245851,444188,731713,797264,166881,491535,861584,412421,454465,509120,322764,927125,396130,805532,867957,385779,746677,449562,900858,24994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003696s ]