SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31909 LIMIT 1 [ RunTime:0.002446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31909 [ RunTime:0.006559s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (433076,1047107,573474,250595,343081,148532,835332,348328,379904,218434,824806,863010,373496,621030,814955,407139,1027658,173706,419193,838440,816490,971570,338401,903839,30937,915551,29098,357187,783174,1042947,43940,319010,558380,778351,434386,670203,1040352,150842,497185,665906,266161,944620,913870,645186,938625,1028507,490842,1014238,545118,150660,945409,987732,854742,238847,832146,826784,809340,143164,202530,60912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31909 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31909 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]