SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002460s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539329 LIMIT 1 [ RunTime:0.000421s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539329 [ RunTime:0.001630s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1133,559502,307807,200570,299380,23304,18943,1020892,726190,416322,815204,288173,660958,732916,70216,412967,826047,240618,537896,526863,179320,833222,770493,776363,644607,831718,23166,211771,650854,632327,664247,619478,523358,77642,292011,122217,1046149,293068,158814,1019499,748193,379089,703172,956073,575050,725913,949148,679953,763031,889754,640257,920744,124984,81357,242636,15361,212774,1015559,934050,161511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000467s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]