SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001391s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530151 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530151 [ RunTime:0.002405s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (515413,542912,970083,480394,656913,587053,858094,292756,601596,559065,383939,919948,639525,18247,1030329,628997,732236,938623,320197,110137,391465,416505,295756,509889,707220,49031,191600,780820,927498,334448,762289,826871,920768,845112,500814,148226,830715,551595,562376,94331,83632,242484,453745,915584,607415,907929,91998,630178,321383,969348,496780,731419,615037,122062,434371,638342,16200,740755,596566,1038872) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005523s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530151 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000631s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530151 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001240s ]