SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004583s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 802418 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 802418 [ RunTime:0.003140s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1005213,969910,572117,622608,351565,412869,1028151,661952,536267,96168,972109,607751,288421,688540,329626,165540,819734,358092,250361,387620,390534,349349,627942,25070,430832,280065,1017906,507944,728807,314251,732774,973461,834721,22756,289606,731599,941012,780549,75994,921381,360703,533874,156516,87595,956831,61952,330045,181605,567723,710041,144437,778931,1033632,583247,555390,283914,210147,884829,792810,1041674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 802418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 802418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]