SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005462s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261835 LIMIT 1 [ RunTime:0.001770s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261835 [ RunTime:0.009292s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (271395,233387,1007300,835552,735610,537724,657516,901337,958649,168037,502355,847333,884130,705173,884095,14612,340356,269258,283671,1047614,598116,195721,714775,787329,584101,70097,576135,392328,77882,846697,270428,419103,587317,983020,480066,684374,514112,219741,484129,715334,100749,548943,946140,26186,875933,1002306,633349,785098,412363,988585,830961,517249,601368,779679,49936,903880,448362,327603,467512,691371) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261835 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002840s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261835 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000536s ]