SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 266183 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 266183 [ RunTime:0.001576s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502316,700412,900013,172193,290700,198162,618839,823673,521128,1011207,659171,616072,891077,474539,153708,1039536,822034,237397,446370,909378,734281,759110,498479,325189,779601,670846,146490,558279,1003747,703112,471515,77293,776590,761330,241235,130769,650714,439034,988442,1006704,942735,677053,752488,792972,253318,514949,68003,944146,110259,604821,750647,532432,352735,199235,970686,1033620,913621,995551,863183,196921) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 266183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 266183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000374s ]