SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34471 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34471 [ RunTime:0.002067s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (793765,513190,397463,843847,630772,722832,608521,211820,128518,608862,446058,693298,360649,536628,746590,243178,797226,240791,809828,709498,338604,898780,308929,551458,741065,447077,533225,835041,226617,119434,935272,195088,137894,769511,1033285,152278,948388,594165,189747,889493,43791,163281,38918,284637,569345,518324,951908,717017,195438,531518,740502,883353,420107,507099,800834,860547,908440,983300,263408,432604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34471 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000472s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34471 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]