SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454923 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454923 [ RunTime:0.001718s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005238,616556,226915,392702,189335,755402,611686,654955,597065,21623,904364,506324,294594,847017,842556,904531,334322,252722,113875,280411,461052,728525,823770,50462,311944,1022927,254874,936289,555059,544233,243276,384264,949344,1017909,970966,93837,36265,598013,217947,844379,279174,299411,115667,496529,505920,523731,994541,669390,654137,206652,526722,183569,944735,985698,569964,283821,737104,514015,508912,602621) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]