SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002496s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 560081 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 560081 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021505,396601,488400,841002,267328,909291,671412,386677,388222,413571,628148,980556,597017,381272,863609,1021158,187191,833747,840878,231563,23747,697198,617746,510716,33999,522961,415244,65108,793832,805670,839068,805835,733845,249934,358842,844248,688462,466866,50629,1020073,823033,353365,577626,349145,493588,738524,217256,130822,774843,786939,152670,157748,730494,766365,340985,408487,728800,536523,616575,606246) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001029s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 560081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 560081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000378s ]