SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001089s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284543 LIMIT 1 [ RunTime:0.000813s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284543 [ RunTime:0.003776s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (11815,588623,12554,138411,700135,1017448,861089,54419,311238,868746,743508,165784,998873,312784,603460,578926,696099,714327,969355,966110,745086,815890,683467,354330,640166,823956,65283,342511,353269,1041299,549324,246821,884794,630518,571027,19563,117009,250249,1024614,350963,76000,908622,344289,27579,185085,890386,889524,177583,533647,596160,824323,722257,263080,836059,288862,353966,750136,406995,516038,507879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001795s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001960s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]