SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001629s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 103201 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 103201 [ RunTime:0.001860s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242292,525193,953256,877277,740757,885137,503237,133428,526629,166980,718139,576660,952086,912624,453220,982003,242118,46434,885953,967574,668345,304169,980828,810473,1030740,49728,423062,708733,426604,199215,405282,589804,423045,794379,562500,284414,339731,25713,448070,222032,946584,184826,1047882,648820,370696,873980,716800,535013,689432,371677,827321,139552,386971,799666,930879,259507,245815,617962,251397,397487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 103201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000589s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 103201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]