SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 442511 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 442511 [ RunTime:0.003231s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (362421,760849,841687,944879,26178,184013,60796,921513,518134,587111,948402,631403,41506,307903,710475,306793,706050,979932,1401,376472,81380,172210,680121,646168,662581,587320,310960,797230,953054,520666,499438,796855,588497,329346,55435,350752,445935,86164,945298,948134,631240,169977,117802,482448,391312,292083,541449,258673,1044232,3058,743208,105535,860328,560914,1006956,201308,262654,728981,554980,174903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 442511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000513s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 442511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001538s ]