SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742813 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742813 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (354164,794714,531446,204564,978341,1015971,784969,986277,920427,467840,162685,287719,208122,224691,889513,616596,791943,464666,847601,325056,596427,812852,443767,592229,1027724,215511,17173,591413,324595,884675,557531,607709,979279,632301,1027650,1015777,684266,736611,103654,95289,191750,149743,603083,983105,1044803,1002780,1034284,472804,861103,360088,404795,313701,926804,503361,602803,71883,209548,137802,647739,851696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000398s ]