SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506743 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506743 [ RunTime:0.001689s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91641,483165,348927,191985,376179,47269,612097,259688,190780,23530,456744,612810,934694,693730,291256,919678,1030696,846738,856640,243255,181511,691897,956302,690201,377496,528040,420012,305090,304262,144365,429679,931104,587541,22981,551735,924133,1027985,1016299,586873,988697,389635,32586,908478,651920,835064,100301,435177,686667,573777,40113,1008439,27004,349333,301734,520202,199854,121151,455465,452617,225091) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001867s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003866s ]