SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001572s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51722 LIMIT 1 [ RunTime:0.000604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51722 [ RunTime:0.002810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415656,10056,147223,371209,336491,698444,85234,848311,1020818,622929,681917,508116,638968,977640,2775,280946,656386,717889,631370,666476,581873,17024,767773,642654,41475,692739,910672,1033746,1032903,5631,325576,884211,837120,481148,94138,603977,1015757,660946,764177,1046014,635314,995585,21099,453938,394851,901116,247172,922925,650561,993681,173891,11617,695727,161241,867693,75566,13910,670142,424670,344349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51722 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000830s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51722 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]