SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285907 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285907 [ RunTime:0.001882s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (599388,177828,584759,732171,874404,821276,16542,240998,556916,244650,906162,873649,731168,106249,52116,6902,907381,534312,366753,416562,669253,51617,410835,466846,632841,240599,726430,638230,66507,1018042,370510,1028870,431805,866260,789155,772950,137811,782473,1009073,883112,345097,917670,74325,1036753,653912,167876,479964,24212,644757,829999,649157,215101,95498,63700,672760,732874,15764,383386,650782,904105) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285907 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285907 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]