SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421894 LIMIT 1 [ RunTime:0.000914s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421894 [ RunTime:0.003364s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (545546,286618,43070,460979,410760,755331,807157,496085,298792,810920,1042025,423775,51303,442021,422035,222544,66550,659402,146350,364330,36925,970780,245451,1043165,999075,500768,312164,590078,419296,974769,457021,893767,210633,964632,412044,750089,580914,269753,313609,889361,561213,637856,918818,31447,290227,881117,884674,248104,823086,77885,761779,910242,923216,517833,253877,114972,589255,956518,1017816,880227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000637s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]