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` = 557654 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557654 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (23430,537683,537725,691815,937426,894559,400505,158440,1045297,241265,1006787,204576,596208,239456,936767,137950,1003486,305723,893489,480273,47035,251128,1035362,90715,1027374,535044,705559,724811,961077,109250,984802,490223,653698,408354,709246,293887,174125,441113,850640,504587,209409,470059,438608,158870,505550,603000,2832,744672,408176,242826,21465,536413,172759,79735,604766,902468,373658,382957,1014779,1027428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557654 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557654 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]