SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505317 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505317 [ RunTime:0.003616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (164528,879509,181469,958735,924100,629788,728897,670003,397841,213885,453127,539187,679853,222598,426256,583135,393459,881104,342605,402919,261726,883113,224921,481233,338531,843002,700624,253901,77547,718230,438084,997286,567721,236491,1019484,356243,72573,132546,417464,931106,806110,603933,545477,263319,193841,483508,368996,3017,640596,1048736,633180,963994,109635,1032400,259939,521089,90522,132585,211738,831395) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003924s ]