SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428012 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428012 [ RunTime:0.002290s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905876,952413,583894,937825,701984,1020099,426302,874993,747240,759695,529704,612114,489142,683948,549655,460463,874079,840793,428034,238195,223213,367921,947480,575837,120589,537428,954161,136956,660245,945114,242888,893404,790847,482586,153230,298554,340899,30106,446899,702845,887401,594988,389380,134698,847350,569790,916932,82773,424006,772069,583219,41863,854125,449525,356109,27907,990467,337103,329346,162016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]