SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312017 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312017 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110020,749794,33390,175920,512360,1015218,496123,470531,408085,166683,359693,307759,113344,926194,483518,409705,361893,486215,6025,458728,459819,165021,464227,130953,738057,958081,645650,781023,906265,439972,824542,1024693,906987,528610,814572,341021,457151,54992,159035,490479,779755,102012,816898,179881,496130,1006926,348755,640300,1006526,1001511,117468,242644,431348,288381,23281,51576,638911,534058,586928,489007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312017 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312017 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]