SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539831 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539831 [ RunTime:0.002258s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (734750,963022,480534,560991,665794,27548,485658,343386,682174,814903,1006003,763438,639445,203726,733090,627776,105098,105442,803760,573416,566152,78388,772410,455560,772017,805722,624574,54712,771908,478276,397394,558155,425974,1044706,232470,111544,190790,489823,866869,490568,711649,911762,1044364,638495,290102,474738,669516,159874,707563,771152,722846,504115,1048784,853691,704773,143966,506128,164238,762496,721088) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539831 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539831 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]