SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000920s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537806 LIMIT 1 [ RunTime:0.003813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537806 [ RunTime:0.008072s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310203,927875,540361,607658,142130,108060,86830,299772,300239,858817,802180,43452,638270,819187,643444,463955,569506,588200,441382,76949,278916,12183,202860,681531,984477,157023,501679,383542,793188,435883,465468,289263,662573,111440,315166,569389,774341,707939,651491,523418,896354,488141,926249,707672,4576,965866,352538,504542,111767,467630,1019737,425813,800655,230449,914486,904087,155793,291225,261798,272111) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001481s ]