SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001433s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427974 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427974 [ RunTime:0.001540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220218,26907,684386,630217,580023,200060,865901,239971,378962,699312,659436,188028,278605,715816,659175,995550,340619,854706,52076,163882,92558,808073,390719,672527,198540,1042526,460211,685769,874135,322916,830066,946474,588412,1010910,962596,584877,598833,49571,947022,576264,212424,867690,451900,531381,405155,790671,964572,359525,572407,714782,567476,728885,833046,1018846,910165,1010295,253060,615704,332875,756770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001016s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427974 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427974 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]