SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002047s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 20412 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 20412 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492929,393050,416339,974921,597895,606357,619730,53337,856443,875094,715760,579345,289685,115688,802458,313896,231769,962749,198028,340451,364947,25337,531472,636692,261888,412642,343787,316988,1036523,565027,988530,7248,67970,242783,32198,875692,236101,997147,862019,1033178,928476,882809,922375,132808,487906,356595,697931,613552,176137,155489,549009,325184,648417,508064,785995,850418,15757,937065,285050,6565) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002685s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 20412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001902s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 20412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]