SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419696 LIMIT 1 [ RunTime:0.000428s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419696 [ RunTime:0.002883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156361,593806,160395,618776,478537,404026,360059,998848,197390,923681,685564,930842,240872,600737,152751,930450,910028,546047,471103,5453,630708,80924,1028965,165503,58981,1042955,454027,237678,132044,893987,266347,91350,30458,72114,726960,612413,906115,45020,616731,170977,451915,501639,156188,841908,653172,948220,362600,65591,598705,779756,637356,179053,156393,634366,774893,659707,132291,942941,571431,429556) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]