SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 642613 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 642613 [ RunTime:0.003164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423019,489378,360418,700606,266584,781231,372900,70419,677143,799952,626691,903915,731903,976510,900613,245736,729026,881471,317367,124829,775108,479870,612223,584471,188504,503929,8650,880224,816614,406872,349071,400488,219198,469597,810949,31769,848655,412316,1002226,114978,239811,979496,113489,184247,941386,325815,592173,739091,431808,761663,144974,310666,301003,1028511,711954,456400,249042,875791,568796,609008) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 642613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 642613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]