SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517131 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517131 [ RunTime:0.001318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180726,392131,212195,734781,626403,185083,703446,604561,724629,74090,1044195,908762,150167,440628,480709,735106,285760,1006525,819889,336898,821563,254587,589767,804954,692106,838073,353510,989340,532522,285426,476186,112924,643743,779325,240585,909307,599097,743514,840761,190991,452033,876250,627762,414484,675058,275262,939889,612618,720408,59983,920237,818830,233494,910890,664858,336833,574313,220961,395081,299336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517131 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517131 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]