SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001866s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 942001 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 942001 [ RunTime:0.002303s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (840387,824307,563242,298162,985730,442810,860844,992109,335580,447193,460337,157568,867493,677769,572853,35694,128803,307877,500494,244004,567686,388670,562412,29829,805758,533366,291173,825334,692834,803168,445294,896366,504936,280790,318526,30931,55765,772914,229411,756504,203190,1039827,385714,367543,772003,366327,132288,491091,232789,753521,746389,246084,616350,997873,950523,692908,1029784,304529,402045,951612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 942001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 942001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]