SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 51144 LIMIT 1 [ RunTime:0.000743s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 51144 [ RunTime:0.002764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (59007,980009,277316,643549,1004447,446199,565680,614335,758501,665079,1009525,680486,632209,664565,408379,746495,301469,164071,836829,159567,850884,369199,600886,720387,521967,857863,709393,1011908,737615,744245,17522,760135,326612,17885,460301,192997,83495,499180,537233,777883,536693,537138,410152,266966,169873,106229,440579,775950,439045,173555,994183,502109,393261,526169,338880,337033,53699,361013,47430,929551) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001903s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 51144 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 51144 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001774s ]