SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294878 LIMIT 1 [ RunTime:0.002575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294878 [ RunTime:0.002017s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1009887,178371,356397,789678,87058,10473,1000439,89706,990088,123076,284895,716474,91541,578318,164154,905100,772713,703426,875100,966992,1037925,679317,896571,49048,951966,545979,519582,508926,202310,477004,776404,898074,97743,1033806,500636,269725,228375,898045,807346,953829,685259,163889,401926,608911,158673,54476,200539,18003,840638,731173,81559,792690,744993,290660,180172,18752,913372,1018511,19068,754257) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294878 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000811s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294878 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002518s ]