SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001354s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 390010 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 390010 [ RunTime:0.002695s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438692,128694,396145,40735,643605,402869,507487,167855,321183,675559,391866,886241,286964,1035366,237097,852444,1034850,507841,518852,776740,189997,292922,560746,310507,514915,827743,496365,175931,783180,575080,486065,71011,178421,312397,837811,247676,1012687,329474,855174,903754,877951,459130,437826,501559,398867,198745,767008,81703,704754,542996,904547,166224,266803,841979,320539,600630,863540,271066,925685,265650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 390010 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 390010 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]