SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 327552 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 327552 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (438379,600992,578418,649589,74903,601390,984512,878298,349315,736636,967650,591952,997089,396083,383474,156629,523675,126010,458980,740117,446869,78169,727799,422706,873450,316323,215290,189738,989679,1004689,996935,409699,270098,40894,1038415,148435,557164,898542,594534,267482,969403,370972,863329,372131,1012175,727704,881364,602792,908037,40141,842437,659158,152223,288095,5654,962425,160497,853041,288253,858619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 327552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 327552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]