SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020576 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020576 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000632,380660,267619,810062,263620,264687,912707,960186,865823,834886,588172,912047,364381,551310,316035,162300,962980,206462,702523,150646,952043,1008994,786847,149035,68908,269722,473634,130932,454317,12890,577989,738930,306336,115193,62767,4353,187833,664121,714586,446876,1033613,504735,690022,907589,905681,1047825,337233,469971,64917,209943,762535,882354,234080,989698,646571,51012,415258,850721,151406,223146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000947s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020576 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020576 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]