SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006171 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006171 [ RunTime:0.001615s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (149603,236855,382493,351829,898728,538045,917533,296079,411661,679825,853078,404630,466639,653661,58150,887831,950855,1017834,51978,167053,377834,427751,498640,803298,257459,253735,555251,977995,235802,777421,106626,447100,1005108,459688,877661,291145,618920,882589,1039802,463063,1003073,385259,460548,988168,147490,541813,1008928,220340,5367,994848,510868,657685,341028,208437,720872,517288,838416,1011161,336909,3870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]