SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544217 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544217 [ RunTime:0.003505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28985,672768,460032,412150,54430,945966,787360,610326,952514,481596,359466,443144,239670,841354,945242,430293,570324,475139,863699,38838,151657,343011,305319,958948,616241,34182,461950,647604,916464,609445,559446,711938,450217,816506,17478,44542,791035,220516,233544,868119,756055,621441,870787,253919,212900,435991,524258,441810,151923,904490,850624,44917,337187,822881,1023223,526456,613700,362740,775864,880913) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]