SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40168 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40168 [ RunTime:0.005439s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (370027,221456,596706,255045,556464,180765,484513,690775,516437,69292,708596,1021178,1020091,1042590,858648,677678,781928,18871,186740,963714,70398,1009564,942741,390093,542741,917319,623334,753187,244386,528629,645608,542126,538088,514270,492466,741292,937501,496418,272537,69727,29286,874162,702724,583691,307303,267517,266469,1037999,143093,568000,337089,154967,726275,996269,422257,1016182,597590,1032966,124912,235835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40168 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40168 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000601s ]