SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003557s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500180 LIMIT 1 [ RunTime:0.003675s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500180 [ RunTime:0.002699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721204,341868,335427,962738,951130,487987,727744,686975,68687,28214,756643,659175,915129,659152,710665,770351,860895,640630,669314,1029723,968999,367444,908404,832596,756884,650880,990157,126695,377725,401167,544076,464804,402835,848397,703357,999738,369895,488879,567529,591925,858639,747012,931217,19770,140416,26865,847912,579883,577238,821888,154955,938218,823704,614106,752525,996466,481514,137230,953537,506265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]