SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001301s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545326 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545326 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38785,421217,1013085,1026432,509045,356442,663035,256239,914330,114007,1035145,756838,923736,866492,530094,122553,873927,753151,441244,675641,46529,274071,650495,1047851,376062,3780,74107,881583,490194,646991,257858,91064,861577,914688,998412,762902,618437,45803,467659,532556,638977,254483,517488,976899,60986,228072,738193,79195,691316,661656,131963,779895,495402,987763,7851,826188,1001194,743076,357286,12026) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545326 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545326 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000820s ]