SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310320 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310320 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260174,1019422,456346,548020,483676,595065,866898,749869,6460,256192,940169,614405,1039422,688845,652851,1038199,398067,824228,544544,118845,730386,177141,837416,1027682,234200,202804,469036,858070,949824,199792,581936,590706,639383,551975,41879,192492,666795,801375,1045977,727320,387635,664306,642925,440909,427583,340499,741097,24317,279216,173516,459882,268007,616382,148776,507078,1008928,920453,464309,388135,440496) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]