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` = 414243 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414243 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (74076,439404,585509,1026790,425806,272289,52087,883518,482714,87,641919,1046737,1016438,783596,877060,425154,104761,929860,460896,710912,785361,829953,528730,915973,98832,757036,437796,720212,291962,97273,377689,538166,672196,438643,546126,136064,361104,983194,313286,974762,812487,135976,355990,499682,538190,700692,507998,284678,296384,372109,924954,279603,67942,345652,1030221,766280,880116,369202,766433,190303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]