SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 527115 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 527115 [ RunTime:0.002095s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (461840,96350,731622,485074,1000058,995311,569324,186136,622921,723192,7683,709901,370825,292216,161157,467472,754940,948257,1017950,710181,364313,166297,782393,332042,937290,970964,358482,1038789,801862,411221,647806,382813,520589,892433,444212,891156,101404,327428,33490,438128,160477,829943,956768,876758,112833,706202,432149,1001265,502729,1007292,107470,375842,956168,68321,450342,323678,97974,364163,844273,617577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 527115 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 527115 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002251s ]