SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455325 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455325 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (386267,1011589,493810,458312,1020313,66769,892362,86008,481134,729802,116161,307044,97160,284669,433892,180464,650615,253518,165639,283131,475231,628482,199023,157509,456694,110213,941922,330554,304270,545318,161774,802749,93061,759521,542080,326007,582380,606736,321791,713519,334088,139052,724496,274840,518902,412445,1045744,515710,258068,907127,101389,261358,666788,269044,615006,24937,776970,543089,1007979,341424) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455325 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455325 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]