SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517806 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517806 [ RunTime:0.001744s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (44351,514256,298944,887845,564650,52941,611887,228854,669778,854439,714038,737169,886652,786586,165511,237360,568846,451216,649396,965264,212899,117422,456623,444802,125810,699574,921034,882458,360831,767174,717847,991749,633275,538501,698389,58186,243190,878676,207816,762503,281881,726534,217288,87758,714059,819877,88599,902370,440431,285302,691132,842119,426632,1033341,813776,349478,330367,408139,170233,383983) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000667s ]