SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545428 LIMIT 1 [ RunTime:0.002860s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545428 [ RunTime:0.003958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583090,172380,894855,389583,47690,360987,863867,895309,920261,771264,418124,838169,451007,752490,542332,774500,822394,700819,410985,494023,477946,686742,756849,276013,312495,687122,776016,132866,417004,556478,621696,1033566,58547,349584,418586,522548,651439,1016549,690143,98635,625596,899469,999739,534129,581672,438449,154000,497862,973495,97237,527705,238577,26349,285796,587499,891104,29091,482449,123751,75680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003874s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000571s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]