SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001094s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555280 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555280 [ RunTime:0.001546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (857892,103580,645146,6016,1003577,864239,230686,924879,932435,360618,683633,786637,361333,400945,1041991,769823,310937,83450,315244,513640,840850,155164,511987,477050,327231,941170,780239,471485,586153,588169,483037,604669,543367,296571,472507,1012691,311575,189514,177359,235885,181319,941978,823339,910396,396092,240169,874705,410181,695492,1013759,819403,554906,1012372,220865,177284,361167,17316,764991,924103,670212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001963s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]