SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40838 LIMIT 1 [ RunTime:0.002217s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40838 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63156,557128,887738,797523,572327,254883,63491,671547,628496,1034753,85789,373033,455422,163951,673479,135086,186786,1029008,334527,843579,1028313,449771,136905,981812,133923,39753,738897,518770,393680,954244,826974,371113,755239,1006278,42610,990323,688976,1018172,250527,206990,314570,564816,768336,340316,1003440,859429,852649,282178,168587,43933,194258,243408,750586,177498,776273,594298,619758,543417,752614,337065) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001007s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40838 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40838 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]