SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404035 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404035 [ RunTime:0.001597s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (721042,602080,352755,716561,880692,769467,832700,184397,139921,14085,1036537,878190,646909,424680,902562,291398,956344,397401,1007258,263819,732822,725211,379359,1047102,299051,652161,75796,329375,388053,165253,373082,847285,651791,450544,206550,910869,720770,470600,20716,1019392,666612,740743,453522,467269,821407,627314,241187,972968,705295,888824,778705,30532,239886,118753,907505,635570,740517,885159,476643,885613) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]