SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 61083 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 61083 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819029,256209,883827,70868,506616,814872,506199,488893,598716,530692,1032770,520295,529228,134004,336658,317874,835122,667829,387169,414162,298416,28601,836140,74635,103419,948596,623066,14052,530525,220466,998328,759851,454381,420248,184580,429454,799215,774761,155731,914619,351450,911213,568004,481784,794120,787622,979676,819570,931843,888327,859567,287527,547273,501130,1043192,968701,841903,19566,659264,718222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 61083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 61083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]