SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565303 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565303 [ RunTime:0.004457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (118286,933080,632603,971125,438104,85152,512246,327253,735934,700191,226421,296386,926057,1044508,290696,909190,870088,74062,921941,299921,465492,105508,977577,18237,458273,563908,607883,394391,494687,874752,153707,209690,791962,737789,22140,129440,39782,69727,355888,1027449,1047403,196615,347684,255468,757525,770797,809208,691296,1031587,241917,6559,172508,230366,65416,293344,770361,482779,436220,281999,637113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565303 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565303 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001841s ]