SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001730s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414987 LIMIT 1 [ RunTime:0.000769s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414987 [ RunTime:0.003283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (232306,610477,915151,399706,1007941,216631,18637,1043710,668057,961807,447691,597376,589063,799016,573821,678374,849905,920182,119355,459035,350723,926012,330857,511576,133609,251745,124237,339450,810610,824293,901053,15138,583169,268840,969642,338589,199441,359792,704102,147540,155424,226971,636817,239874,103505,297792,102869,531491,1044224,714079,433189,965632,911689,769275,81555,908582,691795,250755,6878,363359) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414987 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414987 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]