SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029871 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029871 [ RunTime:0.003459s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505097,93193,104253,256202,911494,606588,184391,688629,328756,22888,131343,17098,142841,775047,547764,850230,400852,259001,590834,1028603,847677,231525,982661,167906,87996,1014962,992771,908868,439538,1026331,37379,544630,637562,341098,435790,83252,1004490,30562,622265,201597,53054,568861,886112,641638,243436,117010,979203,697765,344652,875701,855428,860133,1040962,211286,263690,114578,1028409,534380,767288,939583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029871 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029871 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001898s ]