SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538860 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538860 [ RunTime:0.001452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446153,17258,113805,691411,1009377,783429,975413,137976,239987,360244,425430,918463,107957,972315,102628,393796,916475,585098,163444,338760,569862,134387,118811,644756,574182,547649,650055,539747,560489,1008855,508553,604792,1019700,251250,267031,317779,561517,385125,820337,315109,850031,455405,522179,94928,558244,960674,374352,287335,998613,877574,326411,264150,794931,889174,26741,484111,1046412,667717,1020246,694722) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000469s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]