SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455174 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455174 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (153309,1032354,67826,637008,374068,999670,151542,877574,473198,190898,933420,105459,759575,168102,364490,533767,440280,1001298,228883,202325,518531,944327,242626,1016643,657427,592682,349520,150979,521239,693299,552395,953863,305283,110468,965306,109642,149132,457073,219760,746824,20446,48300,887395,1043752,496546,21532,941228,173295,650663,599455,131176,180398,245366,250923,1043162,457801,470021,680829,231034,788571) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455174 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455174 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]