SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 343191 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 343191 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104806,157820,406307,250078,967078,422150,457746,451285,621363,364340,108965,679616,624973,455469,174375,601774,635227,344390,10393,992646,768792,819821,404354,306981,479637,929241,840320,1001292,532566,168189,583696,175166,776629,191391,702732,996217,259603,377394,1020253,460103,483161,227297,876789,1034270,104229,913109,180578,569435,158527,982078,552404,886061,433198,165464,1000308,850401,248231,595907,202092,311110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 343191 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 343191 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]